USE [PatientRecord]
GO

/****** Object:  StoredProcedure [dbo].[patientinfo]    Script Date: 04/22/2010 02:28:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[patientinfo]
	
@Pid nvarchar(50)

AS
BEGIN

Select PName,Age,Sex,DName,Bp,HCount,HRate from Patient where Pid = @Pid;
   
END


GO


